ConstructSim Standard Template CONNECT Edition Update 1 Help

To Configure XLS Data Input Sources

  1. Open CSST-Admin and expand CSST Set-Up. Double-click Configure XLS Data Inputs.

    The Configure XLS Data Input Sources window opens.

  2. From the drop-down list, select the XLS input group.

    The list of XLS data input sources is updated.

  3. Add other sources by entering information in the Define list of XSL data input sources section.
  4. In the XLS Workbook field, use the Browse button to locate the XLS file, and then click Open.
  5. Looking at the XLS file, determine the worksheet name and range. Input these values in the XLS Worksheet and Worksheet Range fields respectively.
  6. In the XLS file, click the Windows button and select Excel Options.
  7. In the Excel Options dialog, select Formulas and then turn on the R1C1 reference style box. Click OK.
  8. In the Configure XSL Data Input Source form, enter the required properties for each of the attributes.
  9. Click Set-up selected XLS input table when all relevant fields are populated.
  10. Click Test import for selected XLS input table to test the configuration.
  11. Close CSST-Admin.
Parent topic: Configure XLS Data Inputs